home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Business Shareware
/
Business Shareware.iso
/
start
/
gfxapps
/
techplt1
/
tpsheet5.hlp
< prev
next >
Wrap
Text File
|
1992-09-01
|
3KB
|
126 lines
** File: TPSheet5.hlp
** Index: 25
** Sheet View's Data Menu Commands
█ Data menu
This menu contains commands that
relate to sheet data creation and
manipulation.
█ Fill Selection
This menu contains five fill data
methods. They all fill the selected
data block with appropriate
automatically generated numbers.
█ Random
This command fills the selection
with uniform random numbers between
the minimum and maximum range.
█ Algebraic Sequence
This command fills the selection
with an algebraic sequence.
█ Geometric Sequence
This command fills the selection
with a geometric sequence.
█ Gaussian Distribution
This command fills the selection
with a normal distribution whose mean
and variance are specified in the
dialog box.
█ User-Defined Function
This command displays the User Defined
Function dialog box which lets you
specify the range of selection and a
function formula, then TechPlot will
generate data using the function you
defined to calculate data that fill the
range you selected.
█ Sort
The Data | Sort command lets you sort
one or more columns in order.
█ Descriptive Statistics
This command appears in the Data Menu
as Des. Stats. It shows the descriptive
statistics results of the columns in a file
viewer.
█ T-Test
The Data | T-Test command lets you
perform the student t-test for two columns.
█ F-Test
This command perform the F-test which
tests the hypothesis that two samples have
different variances by trying to reject
the null hypothesis that their variances
are actually consistent. The F-value is
the ratio of the larger variance over the
smaller one.
█ Analysis of Variance (ANOVA)
This command appears in the Data Menu
as ANOVA. It performs both one-way and
two-way analyses of variance.
One-way analysis of variance tests the
null hypothesis that the mean of 3 or more
samples are all equal. Two-way analysis of
variance tests both row means and column
means.
█ Linear Regression
This command performs the linear
regression which calculates the slope (a)
and intercept (b) for the equation y=a*x+b
where x is the independent variable and y
is the dependent variable.
█ Non-Parametric Statistics
This command performs the Chi-Squared
test and the sign test.
The Chi-Squared test tests the null
hypothesis that a contingency table of
observed values do not differ from expected
values (i.e. that there is no association
between row and column variables).
The sign test tests the null hypothesis
that a set of sample values, or the
differences between paired sample values,
are randomly distributed about zero (i.e.
that their median equals to zero).